Create a new table from data in existing tables
1) Select the 'Query' menu and select 'Make Table...'. (The Make Table dialog box appears.)
2) In the 'Table Name' box, enter a name for the new table that will be created from data from the tables selected.
3) Do one of the following:
a) To create the new table in the open database, select the 'Current Database' radio button.
b) To create the new table in a different database:
1] Select the 'Another Database' radio button.
2] Enter the path and filename of the other database in the 'File Name' box.
4) Choose 'OK'. (The Make Table dialog box closes.)